Adding databases to a site

Adobe GoLive Dynamic Link supports a variety of content sources for dynamic content offered by Active Server Pages technology:

Access database files (.mdb) Databases created with Microsoft Access.

Microsoft Data Link files (.udl) Links to databases generated by a variety of programs, including FileMaker Pro, Oracle SQl Server, and ODBC databases.

To add an Access database (.mdb) to your Web site:

1 Quit Adobe GoLive, if it is already running.

2 Drag your database file to the Databases folder in your Dynamic Link Config folder on the Web server.

3 Open Adobe GoLive.

The database can now be selected as a content source using Adobe GoLive Dynamic Link.

To add an Oracle SQL Server or ODBC database to your Web site:

1 Quit Adobe GoLive, if it is already running.

2 Navigate to the Databases folder in the Dynamic Link Config folder on the Web server.

3 Right-click and select New > Microsoft Data Link from the Context (shortcut) menu.

This creates a file called New Microsoft Data Link.udl that will serve as a link to the database.

4 Right-click this file and select Rename from the context menu. Give the file an appropriate name.

5 Right-click this file again and select Properties from the context menu.

6 Click the Provider tab and select the appropriate provider for your database.

7 Click Next and fill in the requested information in the Connection tab.

8 Click Test Connection and then OK to save your settings.

Your database can now be selected as a content source using Adobe GoLive Dynamic Link.

If you encounter difficulties as you create the Data Link (.udl) file, please consult with the administrator of the database, the system administrator of your network or Web server, or ISP.

To add a FileMaker Pro database to your Web site:

1 Open the ODBC control panel on your Web server.

2 Click the System DSN tab and click Add.

3 Select the FileMaker Pro driver in the Create New Data Source window and click Finish.

Note: FileMaker Pro must already be installed on the server for its driver to appear as a choice.

4 Enter FMP as the Data Source Name and Description.

5 Select the Use Remote Connection option and set the server address to the IP address of the machine running the FileMaker Pro database.

Important: The FileMaker Pro database will not work with the Web server unless this option is selected. If the database is on the same machine as your Web server, select the Use Remote Connection option, and use the IP address 127.0.0.1.

6 Make sure that FileMaker Pro is running and that the databases you want to use are open. These databases show up as tables in the Dynamic Link New Content Source window.

7 Right-click and select New > Microsoft Data Link from the Context menu. Select the ODBC provider as the Provider and FMP as the Data Source.

If you encounter difficulties as you create the Data Link (.udl) file or configure the ODBC control panel for FileMaker Pro, please consult with the administrator of the database and the system administrator of your network or Web server.

Using Dynamic Link > Configuring a new site > Adding databases to a site